package com.kcyu.sfherp.mapper.ms;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kcyu.sfherp.entity.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface UserMapper extends BaseMapper<User> {

    @Select("select cast(pass as varchar) as pass, name from pass")
    List<User> getUser();

    @Select("select cast(pass as varchar) as pass, name, id from pass where name = '${name}'")
    User getUserByName(@Param("name") String name);

}
